When running a SAS Merchandise Data Integration dimension load job, the program downloads main data sets (such as LV10MAST, LV10CAT, and LV10MERCH), and copies them. The copies are named in the form XXXX_OLD, where XXXX is the name of the main data set. However, in the dm_compare macro, instead of using the existing XXXX_OLD data sets, the process again downloads the main data sets from the database. Downloading again results in additional download time and slows the load process.

To address this issue, modify the dm_compare macro to download the main data set only when the corresponding XXXX_OLD data set does not exist. Contact SAS Technical Support to get a replacement dm_compare.sas file that contains the modification.

To implement the modification, follow these steps:

1. Make a backup copy of $MDI_ROOT/code/sasmacro/dm_compare.sas
2. Save the replacement dm_compare.sas file in $MDI_ROOT/code/sasmacro.

A fix for this issue is planned for a future software release.

Operating System and Release Information